Skip to main content

Resetting a password

To reset a WordPress password through phpMyAdmin, you can follow these steps:

  1. Log in to your cPanel and click on the "phpMyAdmin" icon.
  2. In the left-hand menu, click on the name of your WordPress database.
  3. Click on the "SQL" tab at the top of the screen.
  4. In the "SQL" field, enter the following query, replacing "yourusername" with the username of the user whose password you want to reset and "yourpassword" with the new password you want to set:
UPDATE wp_users SET user_pass = MD5('yourpassword') WHERE user_login = 'yourusername';
  1. Click the "Go" button to execute the query.

This will reset the password for the specified user to the new password you specified in the query. The user will be able to use this password to log in to their WordPress account.

Note: Be sure to back up your database before making any changes to it.